USE [GOSALES_DW]
GO

/****** Object:  Table [dbo].[RETAILER_CONTACT_DIM]    Script Date: 10/18/2012 19:50:47 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[RETAILER_CONTACT_DIM](
	[RETAILER_CONTACT_CODE] [int] NOT NULL,
	[FIRST_NAME] [nvarchar](25) NOT NULL,
	[LAST_NAME] [nvarchar](30) NOT NULL,
	[JOB_POSITION_ES] [nvarchar](50) NOT NULL,
	[GENDER_CODE] [tinyint] NOT NULL,
	[GENDER] [nvarchar](50) NULL,
	[RETAILER_CODE] [int] NOT NULL,
	[COMPANY_NAME] [nvarchar](50) NOT NULL
) ON [PRIMARY]

GO


